{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["StartHere","5.ID","Financial information ","SI and regression Pt 1","Current operations Pt2 & Pt3 ","Franchise operations Pt2 & Pt3","Expected Values Pt3","Sheet9"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"StartHere","index":0,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[[9,2,10,2],[11,2,12,2]]}
[]
[null,"Student Identification Sheet (version5.2)"]
[]
[null,"Name","Melissa salgado"," <<- enter your name here",null,null,"(1)","Add your name to Cell C4 and your Student ID to cell C6. Then  Click [Start Here] to finish loading data."]
[null,null,null,null,null,null,"(2)","Change the file name to include your name. "]
[null,"Student ID",2434822," <<- enter your Student ID here",null,null,"(3)","When done with your work, Click [I'm Done]"]
[null,null,null,null,null,null,"(3)","Upload the file to the applicable iCollege"]
[null,"Date/time",{"$f":"NOW()","v":"2021-04-02T01:24:05.380"},null,null,null,null," assignment folder to receive credit for this workshop/tutorial"]
[null,null,"Spring 2021",null,null,null,"(4)","Never use a file created or started by another student (that is academic dishonesty).\nAll text, codes, writing, data entry, formulas, configuration and instructions must be performed by the individual submitting the work."]
[null,null,"You must use Excel Desktop. Cloud Excel 365 will not work for this class.",null,"2021-04-01T23:34:17.040","Melissa salgado started S01"]
[]
[null,null,"Collaboration Started"]
[]
[null,null,"Individual Challenge started"]
[null,null,"Kurt Schmitz © 2020 Do not post or reproduce."]
[]
[null,"Excel release",{"$f":"INFO(\"release\")","v":"16.0"},"<< Mac Users below 16.24, please update!"]
[null,"OS",{"$f":"INFO(\"OSVERSION\")","v":"Windows (64-bit) NT :.00"},"<< Windows users with version 16.0 are good to go."]

{"sheet":"5.ID","index":1,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Do Not Alter or Delete this Worksheet or you submission cannot be graded!",null,null,null,"DirVer"]
["Action","Name","Panther ID","Date/Time","S01"]
["Start S01","Melissa salgado",2434822,"2021-04-01T23:34:17.010","User"]
["Starter Sheet","None",0,"2020-01-01","C:\\Users\\HP\\AppData\\Local\\Temp"]
[null,null,null,null,"Welcome to Microsoft Excel version 16.0 build 4266 running on Windows (64-bit) NT :.00!"]

{"sheet":"Financial information ","index":2,"n_rows":64,"n_cols":26,"rows_kept":64,"cut":false,"hidden":false,"merged":[[36,1,36,2]]}
["Donut Information ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spring 2021"]
["Based on the below data, create the profit model for Donuts to Go.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Melissa salgado"]
["Assume that each customer will buy one donut and one cup of coffee"]
[" "]
[null,null,null,null,null,"Enter totals "]
[null,"Time period",null,null,"Fixed Costs",{"$f":"C11+C13+C17+C18+C19+C14+C20+C21+C23+C25+C26","v":5550}]
["Revenue: Cup of Coffee",null,4,null,"Varible Costs",{"$f":"C9+C15+C16","v":0.85}]
["Revenue: Donut"," ",3.5,null,"Coffee",{"$f":"C15+C16","v":0.35}]
["Donut ingredients per donunt)","per donut",0.5,null,"Donut",{"$f":"C9","v":0.5}]
["paper products: napkins, plates etc"]
["Insurance","month",200]
[" "]
["Maintenance & Repairs to equipment","month",0]
["Marketing & Promotion: Advertising","month",50]
["Coffee ","per cup",0.25]
["Coffee cups ","per cup",0.1]
["Payroll:  Wages (Owner/ Manager)","month",2500]
["Payroll:  Wages (per Employees)","month",1000,null,null,null,null,null," "]
["Donut and Coffee equipment rent ","month",500]
["Professional Fees: Accounting","month",50]
["Professional Fees: Legal","month",25]
["Powdered and Liquid Beverages",null,0]
["Rent","month",1000]
["Previous research expense for Donuts advancements",null,1500]
["Supplies: Office","month",25]
["Utilities","month",200," "]
[" ",null," "]
[]
[]
["Additional Data"]
["Monthly Production","Lost Sales","Day old revenue","High demand, % above Average","Low Demand, % below average"]
[4000,3,1.25,0.22,0.26]
["Franchise "]
["Monthly Fixed Expense increase",7000]
["Monthly Production Increase",0.32]
["Monthly demand increase",0.24]
["States of Natures ","probabilities "]
["High demand",0.2]
["Average demand",0.55000000000000004]
["Low demand",0.25]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total "]

{"sheet":"SI and regression Pt 1","index":3,"n_rows":102,"n_cols":26,"rows_kept":102,"cut":false,"hidden":false,"merged":[]}
["Month","Demand","Yearly average","Seasonal Index","Average SI","Deseasonalized","Time period",null,null,"Regression Output"]
[1,3209,null,{"$f":"B2/$C$13","v":1.0452768729641695},{"$f":"AVERAGEIF(A$2:A$37,A2,D$2:D$37)","v":0.80717016035692735},{"$f":"B2/E2","v":3975.6177292046987},1,null,"CLICK CELL J2 as output cell for regression",{"$f":"INTERCEPT(F2:F37,Time__period)","v":2997.4129067151748},"Intercept"]
[2,2778,null,{"$f":"B3/$C$13","v":0.90488599348534204},{"$f":"AVERAGEIF(A$2:A$37,A3,D$2:D$37)","v":0.84558627289252108},{"$f":"B3/E3","v":3285.2945808796258},2,null,null,{"$f":"SLOPE(F2:F37,Time__period)","v":21.055302115869903},"Slope"]
[3,2428,null,0.79087947882736154,0.80981038580557207,2998.2327252875466,3]
[4,2996,null,0.97589576547231272,0.86373938248533355,3468.6388750496421,4]
[5,2349,null,0.76514657980456025,0.83715297012368872,2805.9387995158604,5]
[6,3767,null,1.2270358306188924,1.1155046013842609,3376.9470742885546,6]
[7,3338,null,1.0872964169381107,1.0950925932047582,3048.1440754077566,7]
[8,2604.5,null,0.84837133550488597,0.88005850520370588,2959.4623364240315,8]
[9,2251.5,null,0.7333876221498371,0.87149662858830279,2583.4867584595263,9]
[10,3246,null,1.057328990228013,1.1274178795537091,2879.1453984080299,10]
[11,3542,"Put yearly average in below cell ",1.1537459283387621,1.2696264259210912,2789.7970046034152,11]
[12,4331,{"$f":"AVERAGE(B2:B13)","v":3070},1.4107491856677525,1.4773441944801291,2931.6120212081382,12]
[1,2217,null,{"$f":"B14/$C$25","v":0.64513312963771274},0.80717016035692735,2746.6327533957051,13]
[2,2683.5,null,{"$f":"B15/$C$25","v":0.78088171104321258},0.84558627289252108,3173.537799780589,14]
[3,2954.5,null,0.85974101556816529,0.80981038580557207,3648.3849204538947,15]
[4,3235,null,0.94136476065764585,0.86373938248533355,3745.3427105425876,16]
[5,2459,null,0.71555361559726471,0.83715297012368872,2937.3365295911026,17]
[6,3794,null,1.104030263349338,1.1155046013842609,3401.151367096038,18]
[7,4589,null,1.3353702895387749,1.0950925932047582,4190.5132300917303,19]
[8,3087,null,0.89829768659973808,0.88005850520370588,3507.7213409640949,20]
[9,3112,null,0.90557253019060091,0.87149662858830279,3570.8686619258474,21]
[10,3785,null,1.1014113196566273,1.1274178795537091,3357.22899968404,22]
[11,4193,"Put yearly average in below cell ",1.2201367670595082,1.2696264259210912,3302.5462564376398,23]
[12,5129,{"$f":"AVERAGE(B14:B25)","v":3436.5},1.4925069111014113,1.4773441944801291,3471.7705049126162,24]
[1,2674,null,{"$f":"B26/$C$37","v":0.73110047846889947},0.80717016035692735,3312.8082916464209,25]
[2,3112.5,null,{"$f":"B27/$C$37","v":0.85099111414900885},0.84558627289252108,3680.8781076270106,26]
[3,2848.5,null,0.77881066302118929,0.80981038580557207,3517.4900815410119,27]
[4,2465,null,0.67395762132604242,0.86373938248533355,2853.8701024690813,28]
[5,3770,null,1.0307587149692412,0.83715297012368872,4503.3585671242199,29]
[6,3714,null,1.0154477101845523,1.1155046013842609,3329.4349439627531,30]
[7,3155,null,0.86261107313738894,1.0950925932047582,2881.034918487559,31]
[8,3268,null,0.89350649350649347,0.88005850520370588,3713.3894856723882,32]
[9,3568,null,0.97552973342447025,0.87149662858830279,4094.1064864239793,33]
[10,4475,null,{"$f":"B35/$C$37","v":1.2235133287764868},1.1274178795537091,3969.2469679223454,34]
[11,5248.5,"Put yearly average in below cell ",1.4349965823650035,1.2696264259210912,4133.8931616773079,35,null,"Use the average seasonal Index  in the column for year 2018"]
[12,5591.5,{"$f":"AVERAGE(B26:B37)","v":3657.5},{"$f":"B37/$C$37","v":1.5287764866712235},1.4773441944801291,3784.8322827488582,36,"Deseasonalized forecast","Seasonalized forecast"]
[1,null,null,null,0.80717016035692735,null,37,{"$f":"_xlfn.FORECAST.LINEAR(G38,F$2:F$37,Time__period)","v":3776.4590850023615},{"$f":"H38*E2","v":3048.2450852227312},"When you move your forecast to the profit models, you must use an equation, not just copy the values"]
[2,null,null,null,0.84558627289252108,null,38,{"$f":"_xlfn.FORECAST.LINEAR(G39,F$2:F$37,Time__period)","v":3797.5143871182313},{"$f":"H39*E3","v":3211.1260368590315}]
[3,null,null,null,0.80981038580557207,null,39,{"$f":"_xlfn.FORECAST.LINEAR(G40,F$2:F$37,Time__period)","v":3818.5696892341011},3092.3173932641307]
[4,null,null,null,0.86373938248533355,null,40,{"$f":"_xlfn.FORECAST.LINEAR(G41,F$2:F$37,Time__period)","v":3839.624991349971},3316.4353190038782]
[5,null,null,null,0.83715297012368872,null,41,{"$f":"_xlfn.FORECAST.LINEAR(G42,F$2:F$37,Time__period)","v":3860.6802934658408},3231.9799743729227]
[6,null,null,null,1.1155046013842609,null,42,{"$f":"_xlfn.FORECAST.LINEAR(G43,F$2:F$37,Time__period)","v":3881.7355955817106},4330.0939182284728]
[7,null,null,null,1.0950925932047582,null,43,{"$f":"_xlfn.FORECAST.LINEAR(G44,F$2:F$37,Time__period)","v":3902.7908976975805},4273.9174048955692]
[8,null,null,null,0.88005850520370588,null,44,{"$f":"_xlfn.FORECAST.LINEAR(G45,F$2:F$37,Time__period)","v":3923.8461998134508},3453.2142212570675]
[9,null,null,null,0.87149662858830279,null,45,{"$f":"_xlfn.FORECAST.LINEAR(G46,F$2:F$37,Time__period)","v":3944.9015019293206},3437.9683590443351]
[10,null,null,null,1.1274178795537091,null,46,{"$f":"_xlfn.FORECAST.LINEAR(G47,F$2:F$37,Time__period)","v":3965.9568040451904},4471.2906104182339]
[11,null,null,null,1.2696264259210912,null,47,{"$f":"_xlfn.FORECAST.LINEAR(G48,F$2:F$37,Time__period)","v":3987.0121061610603},5062.0159304493891]
[12,null,null,null,1.4773441944801291,null,48,{"$f":"_xlfn.FORECAST.LINEAR(G49,F$2:F$37,Time__period)","v":4008.0674082769301},{"$f":"H49*E13","v":5921.2951167029396}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Melissa salgado"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spring 2021"]

{"sheet":"Current operations Pt2 & Pt3 ","index":4,"n_rows":201,"n_cols":26,"rows_kept":201,"cut":false,"hidden":false,"merged":[]}
["CURRENT OPERATIONS",null,null,null,"Monthly Production","Lost Sales","Day old revenue",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"test"]
["Part 2",null,null,null,{"$f":"'Financial information '!A32","v":4000},{"$f":"'Financial information '!B32","v":3},{"$f":"'Financial information '!C32","v":1.25},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summer 2020 "]
["AVERAGE DEMAND"]
["Month ","January","February","March","April","May","June","July","August","September","October","November","December"]
["Demand",{"$f":"'SI and regression Pt 1'!I38","v":3048.2450852227312},{"$f":"'SI and regression Pt 1'!I39","v":3211.1260368590315},{"$f":"'SI and regression Pt 1'!I40","v":3092.3173932641307},{"$f":"'SI and regression Pt 1'!I41","v":3316.4353190038782},{"$f":"'SI and regression Pt 1'!I42","v":3231.9799743729227},{"$f":"'SI and regression Pt 1'!I43","v":4330.0939182284728},{"$f":"'SI and regression Pt 1'!I44","v":4273.9174048955692},{"$f":"'SI and regression Pt 1'!I45","v":3453.2142212570675},{"$f":"'SI and regression Pt 1'!I46","v":3437.9683590443351},{"$f":"'SI and regression Pt 1'!I47","v":4471.2906104182339},{"$f":"'SI and regression Pt 1'!I48","v":5062.0159304493891},{"$f":"'SI and regression Pt 1'!I49","v":5921.2951167029396}]
["satisfied demand",{"$f":"MIN($E$2,B5)","v":3048.2450852227312},{"$f":"MIN($E$2,C5)","v":3211.1260368590315},3092.3173932641307,3316.4353190038782,3231.9799743729227,4000,4000,3453.2142212570675,3437.9683590443351,4000,4000,4000]
["Extra donuts(over) ",{"$f":"E2-$B$6","v":951.75491477726882},{"$f":"$E$2-C6","v":788.8739631409685},{"$f":"$E$2-D6","v":907.68260673586929},683.56468099612175,768.0200256270773,0,0,546.78577874293251,562.0316409556649,0,0,0]
["Unsatisfied customers (short)",{"$f":"B5-B6","v":0},{"$f":"C5-C6","v":0},0,0,0,330.09391822847283,273.91740489556923,0,0,471.29061041823388,1062.0159304493891,1921.2951167029396]
["Revenue"]
["coffee ",{"$f":"'Financial information '!$C$7*B6","v":12192.980340890925},{"$f":"'Financial information '!$C$7*C6","v":12844.504147436126},{"$f":"'Financial information '!$C$7*D6","v":12369.269573056523},{"$f":"'Financial information '!$C$7*E6","v":13265.741276015513},{"$f":"'Financial information '!$C$7*F6","v":12927.919897491691},{"$f":"'Financial information '!$C$7*G6","v":16000},{"$f":"'Financial information '!$C$7*H6","v":16000},{"$f":"'Financial information '!$C$7*I6","v":13812.85688502827},{"$f":"'Financial information '!$C$7*J6","v":13751.87343617734},{"$f":"'Financial information '!$C$7*K6","v":16000},{"$f":"'Financial information '!$C$7*L6","v":16000},{"$f":"'Financial information '!$C$7*M6","v":16000}]
["donut",{"$f":"'Financial information '!$C$8*B6","v":10668.85779827956},{"$f":"'Financial information '!$C$8*C6","v":11238.941129006611},{"$f":"'Financial information '!$C$8*D6","v":10823.110876424458},{"$f":"'Financial information '!$C$8*E6","v":11607.523616513574},{"$f":"'Financial information '!$C$8*F6","v":11311.929910305229},{"$f":"'Financial information '!$C$8*G6","v":14000},{"$f":"'Financial information '!$C$8*H6","v":14000},{"$f":"'Financial information '!$C$8*I6","v":12086.249774399736},{"$f":"'Financial information '!$C$8*J6","v":12032.889256655173},{"$f":"'Financial information '!$C$8*K6","v":14000},{"$f":"'Financial information '!$C$8*L6","v":14000},{"$f":"'Financial information '!$C$8*M6","v":14000}]
["Revenue from day old sales ",{"$f":"$G$2*B7","v":1189.693643471586},{"$f":"$G$2*C7","v":986.09245392621062},1134.6032584198365,854.45585124515219,960.02503203384663,0,0,683.48222342866563,702.53955119458112,0,0,0]
["Total Revenue",{"$f":"SUM(B10:B12)","v":24051.531782642069},{"$f":"SUM(C10:C12)","v":25069.537730368949},24326.983707900818,25727.720743774236,25199.874839830765,30000,30000,26582.588882856671,26487.302244027094,30000,30000,30000]
["Expenses"]
["Fixed Expenses"]
["Total Fixed Expense",{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550}]
[]
["Variable Expenses"]
["Coffee Variable expense",{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400}]
["Donut Variable expense",{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000}]
["Total Variable Expenses",{"$f":"B19+B20","v":3400},{"$f":"C19+C20","v":3400},3400,3400,3400,3400,3400,3400,3400,3400,3400,3400]
["Expenses: due to lost sales",{"$f":"$F$2*B8","v":0},{"$f":"$F$2*C8","v":0},0,0,0,{"$f":"$F$2*G8","v":990.28175468541849},821.7522146867077,0,0,1413.8718312547016,3186.0477913481673,5763.8853501088188]
["Total  Expenses",{"$f":"B16+B21+B22","v":8950},{"$f":"C16+C21+C22","v":8950},8950,8950,8950,9940.2817546854185,9771.7522146867086,8950,8950,10363.871831254703,12136.047791348166,14713.88535010882]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee",{"$f":"B13-B23","v":15101.531782642069},{"$f":"C13-C23","v":16119.537730368949},15376.983707900818,16777.720743774236,16249.874839830765,20059.71824531458,20228.247785313291,17632.588882856671,17537.302244027094,19636.128168745297,17863.952208651834,15286.11464989118,{"$f":"SUM(B25:M25)","v":207869.70098931677}]
[]
["Part 3","You should be able to copy from average to high and low and then just make some modifications"]
["HIGH DEMAND"]
["Month "]
["Demand"]
["satisfied demand"]
["Extra donuts(over) "]
["Unsatisfied customers (short)"]
["Revenue"]
["coffee "]
["donut"]
["Revenue from day old sales "]
["Total Revenue"]
["Expenses"]
["Fixed Expenses"]
["Total Fixed Expense"]
[]
["Variable Expenses"]
["Coffee Variable expense"]
["Donut Variable expense"]
["Total Variable Expenses"]
["Expenses: due to lost sales"]
["Total  Expenses"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee"]
[]
["Part 3"]
["LOW DEMAND"]
["Month "]
["Demand"]
["satisfied demand"]
["Extra donuts(over) "]
["Unsatisfied customers (short)"]
["Revenue"]
["coffee "]
["donut"]
["Revenue from day old sales "]
["Total Revenue"]
["Expenses"]
["Fixed Expenses"]
["Total Fixed Expense"]
[]
["Variable Expenses"]
["Coffee Variable expense"]
["Donut Variable expense"]
["Total Variable Expenses"]
["Expenses: due to lost sales"]
["Total  Expenses"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Melissa salgado"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spring 2021"]

{"sheet":"Franchise operations Pt2 & Pt3","index":5,"n_rows":75,"n_cols":14,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
["FRANCHISE",null,null,null,"Monthly Production","Lost Sales","Day old revenue"]
["Part 2",null,null,null,{"$f":"'Financial information '!A32*1.32","v":5280},{"$f":"'Financial information '!B32","v":3},{"$f":"'Financial information '!C32","v":1.25}]
["AVERAGE DEMAND"]
["Month ","January","February","March","April","May","June","July","August","September","October","November","December"]
["Demand",{"$f":"'Current operations Pt2 & Pt3 '!B5*1.24","v":3779.8239056761868},{"$f":"'Current operations Pt2 & Pt3 '!C5*1.24","v":3981.7962857051989},{"$f":"'Current operations Pt2 & Pt3 '!D5*1.24","v":3834.473567647522},{"$f":"'Current operations Pt2 & Pt3 '!E5*1.24","v":4112.3797955648088},{"$f":"'Current operations Pt2 & Pt3 '!F5*1.24","v":4007.655168222424},{"$f":"'Current operations Pt2 & Pt3 '!G5*1.24","v":5369.3164586033063},{"$f":"'Current operations Pt2 & Pt3 '!H5*1.24","v":5299.6575820705057},{"$f":"'Current operations Pt2 & Pt3 '!I5*1.24","v":4281.9856343587635},{"$f":"'Current operations Pt2 & Pt3 '!J5*1.24","v":4263.0807652149751},{"$f":"'Current operations Pt2 & Pt3 '!K5*1.24","v":5544.4003569186098},{"$f":"'Current operations Pt2 & Pt3 '!L5*1.24","v":6276.8997537572423},{"$f":"'Current operations Pt2 & Pt3 '!M5*1.24","v":7342.4059447116451}]
["satisfied demand",{"$f":"MIN($E$2,B5)","v":3779.8239056761868},{"$f":"MIN($E$2,C5)","v":3981.7962857051989},{"$f":"MIN($E$2,D5)","v":3834.473567647522},4112.3797955648088,4007.655168222424,5280,5280,4281.9856343587635,4263.0807652149751,5280,5280,5280]
["Extra donuts(over) ",{"$f":"$E$2-B6","v":1500.1760943238132},{"$f":"$E$2-C6","v":1298.2037142948011},1445.526432352478,1167.6202044351912,1272.344831777576,0,0,998.01436564123651,1016.9192347850249,0,0,0]
["Unsatisfied customers (short)",{"$f":"B5-B6","v":0},{"$f":"C5-C6","v":0},0,0,0,89.316458603306273,19.657582070505669,0,0,264.40035691860976,996.89975375724225,2062.4059447116451]
["Revenue"]
["coffee ",{"$f":"'Financial information '!$C$7*B6","v":15119.295622704747},{"$f":"'Financial information '!$C$7*C6","v":15927.185142820796},{"$f":"'Financial information '!$C$7*D6","v":15337.894270590088},{"$f":"'Financial information '!$C$7*E6","v":16449.519182259235},{"$f":"'Financial information '!$C$7*F6","v":16030.620672889696},{"$f":"'Financial information '!$C$7*G6","v":21120},{"$f":"'Financial information '!$C$7*H6","v":21120},{"$f":"'Financial information '!$C$7*I6","v":17127.942537435054},{"$f":"'Financial information '!$C$7*J6","v":17052.323060859901},{"$f":"'Financial information '!$C$7*K6","v":21120},{"$f":"'Financial information '!$C$7*L6","v":21120},{"$f":"'Financial information '!$C$7*M6","v":21120}]
["donut",{"$f":"'Financial information '!$C$8*B6","v":13229.383669866653},{"$f":"'Financial information '!$C$8*C6","v":13936.286999968197},{"$f":"'Financial information '!$C$8*D6","v":13420.657486766328},{"$f":"'Financial information '!$C$8*E6","v":14393.329284476831},{"$f":"'Financial information '!$C$8*F6","v":14026.793088778484},{"$f":"'Financial information '!$C$8*G6","v":18480},{"$f":"'Financial information '!$C$8*H6","v":18480},{"$f":"'Financial information '!$C$8*I6","v":14986.949720255672},{"$f":"'Financial information '!$C$8*J6","v":14920.782678252413},{"$f":"'Financial information '!$C$8*K6","v":18480},{"$f":"'Financial information '!$C$8*L6","v":18480},{"$f":"'Financial information '!$C$8*M6","v":18480}]
["Revenue from day old sales ",{"$f":"$G$2*B7","v":1875.2201179047665},{"$f":"$G$2*C7","v":1622.7546428685014},1806.9080404405975,1459.525255543989,1590.4310397219701,0,0,1247.5179570515456,1271.1490434812811,0,0,0]
["Total Revenue",{"$f":"B10+B11+B12","v":30223.899410476166},{"$f":"C10+C11+C12","v":31486.226785657494},30565.459797797012,32302.373722280056,31647.844801390151,39600,39600,33362.410214742275,33244.254782593598,39600,39600,39600]
["Expenses"]
["Fixed Expenses"]
["Total Fixed Expense",{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550}]
[]
["Variable Expenses"]
["Coffee Variable expense",{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998}]
["Donut Variable expense",{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640}]
["Total Variable Expenses",{"$f":"B19+B20","v":4488},{"$f":"C19+C20","v":4488},4488,4488,4488,4488,4488,4488,4488,4488,4488,4488]
["Expenses: due to lost sales",{"$f":"$F$2*B8","v":0},{"$f":"$F$2*C8","v":0},0,0,0,267.94937580991882,58.972746211517006,0,0,793.20107075582928,2990.6992612717268,6187.2178341349354]
["Total  Expenses",{"$f":"B16+B21+B22","v":17038},{"$f":"C16+C21+C22","v":17038},17038,17038,17038,17305.94937580992,17096.972746211519,17038,17038,17831.201070755829,20028.699261271726,{"$f":"M16+M21+M22","v":23225.217834134935}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee",{"$f":"B13-B23","v":13185.899410476166},{"$f":"C13-C23","v":14448.226785657494},13527.459797797012,15264.373722280056,14609.844801390151,22294.05062419008,22503.027253788481,16324.410214742275,16206.254782593598,21768.798929244171,19571.300738728274,16374.782165865065,{"$f":"SUM(B25:M25)","v":206078.42922675284}]
[]
["Part 3"]
["HIGH DEMAND"]
["Month "]
["Demand"]
["satisfied demand"]
["Extra donuts(over) "]
["Unsatisfied customers (short)"]
["Revenue"]
["coffee "]
["donut"]
["Revenue from day old sales "]
["Total Revenue"]
["Expenses"]
["Fixed Expenses"]
["Total Fixed Expense"]
[]
["Variable Expenses"]
["Coffee Variable expense"]
["Donut Variable expense"]
["Total Variable Expenses"]
["Expenses: due to lost sales"]
["Total  Expenses"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee"]
[]
["Part 3"]
["LOW DEMAND"]
["Month "]
["Demand"]
["satisfied demand"]
["Extra donuts(over) "]
["Unsatisfied customers (short)"]
["Revenue"]
["coffee "]
["donut"]
["Revenue from day old sales "]
["Total Revenue"]
["Expenses"]
["Fixed Expenses"]
["Total Fixed Expense"]
[]
["Variable Expenses"]
["Coffee Variable expense"]
["Donut Variable expense"]
["Total Variable Expenses"]
["Expenses: due to lost sales"]
["Total  Expenses"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee"]

{"sheet":"Expected Values Pt3","index":6,"n_rows":57,"n_cols":14,"rows_kept":57,"cut":false,"hidden":false,"merged":[[46,2,46,4],[54,2,54,4],[2,2,2,4],[10,2,10,4],[17,2,17,4],[24,2,24,4],[31,2,31,4],[38,2,38,4]]}
[null,"PAYOFF TABLE"]
[]
[null,null,"State of Nature",null,null,null,null,"Summary of Results ","Methods "]
[null,"Decision Alternatives","Low ","Average ","High ",null,null,{"$f":"B4","v":"Decision Alternatives"},"Maximin","MaxiMax","Laplace ","MinMax regret","EVUII","EOL"]
[]
[]
[null,null,null,null,null,null,null,"Decision Alternatives"]
[null,"DM UNDER IGNORANCE"]
[null,null,null,null,null,null,null,"Kiana should choose to:"]
[null,"Maximin"]
[null,null,"State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High ",null,null,"Because:"]
[]
[]
[]
[]
[null,"Maximax"]
[null,null,"State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High "]
[]
[]
[]
[]
[null,"Laplace"]
[null,null,"State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High "]
[]
[]
[]
[]
[null,"Minimax Regret"]
[null,"Regret table","State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High "]
[]
[]
[]
[null,"DM UNDER RISK"]
[null,"EVUII"]
[null,null,"State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High "]
[null,"Probability"]
[]
[]
[]
[]
[null,"EVUPI"]
[null,null,"State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High "]
[null,"Probability"]
[]
[]
[null,"EVPI"]
[]
[null,"EOL"]
[null,"Regret table","State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High "]
[null,"Probability"]

{"sheet":"Sheet9","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}